package cn.gdsdxy.dao;

import cn.gdsdxy.pojo.Appraise;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface AppraiseMapper {
    @Select("select * from a_appraise where goods_id =#{id}")
    List<Appraise> getidappraise(int id);

    @Insert("insert into a_appraise (goods_id,appraise,customer,time) values (#{goods_id},#{appraise},#{customer},#{time})")
    int addAppraise(Appraise appraise);
}
